CODEBOOK: state_bm_contributions Dataset

Dataset: Raw campaign contributions data
Description: Individual and organizational contributions to direct democracy campaigns across states

================================================================================

VARIABLE DESCRIPTIONS

1. year
   Variable Name: year
   Description: Year of the ballot measure election
   Data Type: Numeric
   Values: Year values (e.g., 2016, 2018, 2020, etc.)
   Source: State campaign finance databases

2. bm_state
   Variable Name: bm_state
   Description: State where the ballot measure appeared (two-letter abbreviation)
   Data Type: Character/String
   Values: Two-letter state codes (e.g., "SD", "CA", "FL", etc.)
   Source: State campaign finance databases

3. ballot_measure
   Variable Name: ballot_measure
   Description: Official designation or name of the ballot measure
   Data Type: Character/String
   Values: Ballot measure names/numbers (e.g., "AMENDMENT T", "Proposition 1", etc.)
   Source: State campaign finance databases

4. committee_name
   Variable Name: committee_name
   Description: Name of the committee that received the contribution
   Data Type: Character/String
   Values: Committee names (e.g., "#SDRTTHING2DO", etc.)
   Source: State campaign finance databases

5. status
   Variable Name: status
   Description: Electoral outcome of the ballot measure
   Data Type: Character/String
   Values: "PASSED", "FAILED"
   Source: State election results

6. description
   Variable Name: description
   Description: Brief description of the ballot measure's subject matter
   Data Type: Character/String
   Values: Description text (e.g., "Legislative Redistricting", etc.)
   Source: State ballot measure descriptions

7. contributor_name
   Variable Name: contributor_name
   Description: Name of the individual or organization making the contribution
   Data Type: Character/String
   Values: Contributor names (e.g., "sdea nea", "sd farmers union", etc.)
   Source: State campaign finance databases

8. city
   Variable Name: city
   Description: City of contributor's address
   Data Type: Character/String
   Values: City names (e.g., "PIERRE", "HURON", "SIOUX FALLS") or NULL for missing data
   Source: State campaign finance databases

9. state
   Variable Name: state
   Description: State of contributor's address (two-letter abbreviation)
   Data Type: Character/String
   Values: Two-letter state codes (e.g., "SD", "CA", etc.) or NULL for missing data
   Source: State campaign finance databases

10. zip
    Variable Name: zip
    Description: ZIP code of contributor's address
    Data Type: Character/String
    Values: 5-digit ZIP codes (e.g., "57501", "57350") or NULL for missing data
    Source: State campaign finance databases

11. amount
    Variable Name: amount
    Description: Dollar amount of the individual contribution
    Data Type: Numeric
    Values: Dollar amounts (e.g., 2000.00, 148941.14, 611.52, etc.)
    Units: U.S. Dollars
    Source: State campaign finance databases

12. total
    Variable Name: total
    Description: Total amount raised by the committee for a particular measure
    Data Type: Numeric
    Values: Dollar amounts (e.g., 335338.43, etc.)
    Units: U.S. Dollars
    Source: State campaign finance databases

13. date
    Variable Name: date
    Description: Date the contribution was made
    Data Type: Date/Character
    Values: Date values or NULL for missing data; some formatted as "0000-00-00" for invalid dates
    Format: MM-DD-YYYY or NULL
    Source: State campaign finance databases

14. position
    Variable Name: position
    Description: Committee's position on the ballot measure
    Data Type: Character/String
    Values: "Support", "Oppose"
    Source: State campaign finance databases

15. committee_ID
    Variable Name: committee_ID
    Description: Unique identifier for the committee
    Data Type: Numeric
    Values: Numeric ID codes (e.g., 39762330, etc.)
    Source: State campaign finance databases

16. subject
    Variable Name: subject
    Description: General subject category of the ballot measure
    Data Type: Character/String
    Values: Subject categories (e.g., "Re-districting-Legislative", etc.)
    Source: Coding based on FollowTheMoney coding scheme

17. sub_narrow
    Variable Name: sub_narrow
    Description: More specific categorization of contributor type or industry
    Data Type: Character/String
    Values: Industry/sector categories (e.g., "Labor", "Agriculture", "Uncoded", "Unitemized Contributions")
    Source: Author coding based on contributor information

18. EntityType
    Variable Name: EntityType
    Description: Classification of contributor as individual or organizational entity
    Data Type: Character/String
    Values: "Individual", "Non-Individual", "Other"
    Source: State campaign finance databases

================================================================================

DATA SOURCES AND CITATIONS

1. State Campaign Finance Databases: Individual state disclosure databases as listed in dd_threshold dataset
2. State Election Results: Official state election offices for ballot measure outcomes
3. State Ballot Measure Descriptions: Official state sources for ballot measure text and descriptions
4. Author Coding supplemented by FollowTheMoney): Subject and sub_narrow 

================================================================================

NOTES

- NULL values indicate missing or unavailable data in original state databases
- Date field may contain "0000-00-00" for invalid or missing dates
- Contributor names are as reported in original state databases (may include variations in formatting)
- Amount represents individual contribution amounts, while total represents committee totals

================================================================================

SAMPLE OBSERVATIONS

year | bm_state | ballot_measure | contributor_name | amount    | position | EntityType
-----|----------|---------------|------------------|-----------|----------|-------------
2016 | SD       | AMENDMENT T   | sdea nea         | 2000.00   | Support  | Non-Individual
2016 | SD       | AMENDMENT T   | sd farmers union | 148941.14 | Support  | Non-Individual
2016 | SD       | AMENDMENT T   | raise south dakota| 611.52   | Support  | Non-Individual